An error occurred: (MySQLdb.OperationalError) (1054, "Unknown column 'a.aptName_max' in 'field list'") [SQL: select a.rgnCode, a.conAptCode, if(min(a.aptName) = max(a.aptName), min(a.aptName), concat(min(a.aptName), '~', max(a.aptName))) aptName, c.sido, c.gugun, c.dong, c.bjri, max(a.aptAddr) aptAddr, max(a.doroAddr) doroAddr, max(conYear) conYear, ifnull(max(a.danjyHonum), sum(a.hoNum)) hoNum from ( select a.rgnCode, a.conAptCode, b.conAptNo, if(min(a.aptName_max) = max(a.aptName_max), min(a.aptName_max), max(a.aptName_max)) aptName, b.aptUnit, ifnull(b.hoNum, 0) hoNum, if(a.con_addrNum='', a.aptAddr, a.con_addrNum) aptAddr, if(a.con_doroAddr='', a.doroAddr, a.con_doroAddr) doroAddr, max(if(ifnull(a.useDateMin, '') ='', a.conYear_min, a.useDateMin)) conYear, max(a.hoNum) danjyHonum from mydb.apt_list_4 a left join mydb.apt_list_4 b on a.aptNo=b.aptCode where a.rgnCode like %s and a.conAptCode=b.conAptCode and b.aptUnit is not null and a.rgnCode=a.con_rgnCode and a.addr_closed is null -- 말소 group by a.rgnCode, a.conAptCode, b.conAptNo, b.aptUnit, hoNum, aptAddr, doroAddr) a left join region_list c on a.rgnCode=c.rgnCode group by a.rgnCode, conAptCode, c.sido, c.gugun, c.dong, c.bjri order by aptName ] [parameters: ('4874040028%',)] (Background on this error at: https://sqlalche.me/e/20/e3q8)